SAVi Invoice Export
Introduction
An export file is required to process invoices for Paybill customers. The export file contains all the invoices (Credits are not included) created within ViSN for the following rate cards
- The rate card types include:
- ViSN with DI Network and Paybill
- ViSN Hybrid - Customer’s Network and DI Network with Paybill This is not fully implemented
- ViSN
Purpose
Invoices for the Paybill suppliers are processed using this exports. Savi exports file is imported into Quickbooks for creating bills for each suppliers. Suppliers will be paid by the information imported into Quickbooks.
Since a daily manual process was laborious and error prone, a direct API integration was introduced in the mid of May 2024.
SAVi Invoice Export exports may be deprecated once the API integration has been battle tested.
File format
comma-separated values - *.csv
Fields
| Column Position | Header Name | Description | Datatype | Validation | Max length | Mandatory | Default Value | Example |
|---|---|---|---|---|---|---|---|---|
| A | Bill Number | Supplier Invoice Number | string | A-Z, 0-9 | 20 | Yes | Invoice8794 | |
| B | Supplier Name | Service Unit Name | string | A-Z, 0-9 | 50 | Yes | Grand Repair 01 | |
| C | Bill Date | Supplier Invoice Date - Tax Point Date | string | Date (dd/MM/yyyy format) | 10 | Yes | 02/11/2022 | |
| D | Due Date | leave blank | ||||||
| E | Terms | leave blank | ||||||
| F | Location | leave blank | ||||||
| G | Memo | ViSN Enquiry Number | number | 0-9 | 10 | Yes | 8794 | |
| H | Account | Lease Customer Name | string | A-Z, 0-9 | 50 | Yes | Next Fleet Service | |
| I | Line Description | Job line type | string | A-Z | 100 | Yes | MAINTENANCE REPAIR | |
| J | Line Amount | Supplier invoice job line amount (pre-VAT) | number | 0-9 | 9 | Yes | 69.96 | |
| K | Line Tax Code | Supplier invoice line VAT Rate | string | A-Z, 0-9 and special characters | 20 | Yes | Standard -20% | |
| L | Line Tax Amount | leave blank | ||||||
| M | Type | For invoiced joblines (I) For credited joblines (C) | string | A-Z | 1 | Yes | C | |
| N | VRN | Vehicle Registration Number (VRM) | string | A-Z, 0-9 | 10 | Yes | DU20DDC | |
| O | Currency | Enquiry Currency Type (Use customer currency type as per DI settings at the time of creating an enquiry) | string | A-Z, | 5 | Yes | For UK customers - GBP For Ireland customers - Euro | GBP |
Data source
Once an invoice is created for an enquiry, Savi data is generated and prepared for export
The generated data is maintained in Firebase at
doc: /leasecompany/[leasecompanyId]/exports/[year]/[month]/[date]/enquiries/[enquiryId]
attribute: "SAViData"
sample data:
SAViData:["Invoice No-10174,Dreamline Group,22/04/2024,,,,10174,Dreamline Car Leasing,SERVICE,830.92,STANDARD -20%,,I,RX67OAS,GBP"]
Setup Required
A Scheduler is required to merge all the SAVi data generated for all enquiries that were invoiced for the day.
- Name: generateSAViPayBillExport
- Region: europe-west2
- Frequency: 30 23 * * *
- TimeZone: GMT London
- Topic: projects/biddirect-2/topics/generateSAViPayBillExport
- Message body: a JSON object including the following parameters
- dateTimeStamp: in format yyyy-MMM-dd ex 2022-Sep-30 , when skipped it will default to current date
Downloading SAVi Invoice export file
Savi Invoice export file can be downloaded via DI Admin for a given day
Status: Accepted
Category: Protected
Authored By: Jeyakumar Arunagiri on Feb 09, 2024
Revisions
19 Apr, 2024 - Renamed SAVi Invoice Export label and updated details for rate card type - VN-12200
Revisions
29th May, 2024 - Modify SAVi Invoice Exports with correct information
- https://myvisn.atlassian.net/browse/VN-12863
Authored by: Vishwa Kumar